External data source Limitations

• Data consistency is not guaranteed
• External data source might not have as high performances as BigQuery
• Can't run jobs to export data
• Can't reference external data source in wildcard tables
• Partition or clustering might be limited
• No caching